UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4M4rSI4inGfryw23dnqk4z+PJ36egF5IDAE5AXJweOM='
WHERE
key_id = '0e9bdfef33f6f20724021f259c14865f9874fc7927c6e9c782cb54c8a20436ed'
AND (
token = '4M4rSI4inGfryw23dnqk4z+PJ36egF5IDAE5AXJweOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)