UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g12YS4suWuUkiHGrzmV1bSa3j+rzvFheTtE9zSSrOLA='
WHERE
key_id = '41c075ab00344c556f8776998b05f76dc0919dca0cc3b078c77aec278a9a1879'
AND (
token = 'g12YS4suWuUkiHGrzmV1bSa3j+rzvFheTtE9zSSrOLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)