UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tX7ummIAl/4DHs+JCarsPr92xPjwdR0U3KDV//N5jjQ='
WHERE
key_id = 'd5a57f3d938e62aca9a887b4a678eabd6412ae6d8855ba59b0849a24fcafc3c8'
AND (
token = 'tX7ummIAl/4DHs+JCarsPr92xPjwdR0U3KDV//N5jjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)