UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mdtJttSaoFwIhhlP0NwD58GU77VOr6E7JUIq++GaUi8='
WHERE
key_id = 'edb481e2a02aa05f7d5f6169e7fae9a926a4e459c240c27928554e962e20cb00'
AND (
token = 'mdtJttSaoFwIhhlP0NwD58GU77VOr6E7JUIq++GaUi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)