UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hoB1LPyxLpcIMgot7njHJ389R/dNhZPEKYnxcOi9RI='
WHERE
key_id = 'e447cab42bc058f27dc0ea6163de2c644eddfb0ce6de6c73ad445aa7d5211bc2'
AND (
token = '9hoB1LPyxLpcIMgot7njHJ389R/dNhZPEKYnxcOi9RI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)