UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'erYVTnHzDWo593mwRioHX6msZFOhIycY0Ahil+8WMR0='
WHERE
key_id = 'be3e96ee7d0e4f2a5d90f1b838c089366ea8e5f29b90fc39d49a5d12af6f5f7f'
AND (
token = 'erYVTnHzDWo593mwRioHX6msZFOhIycY0Ahil+8WMR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)