UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+GTrit8+0ykJih/flC/ySbzq42daOA0djK7ngQJUbb0='
WHERE
key_id = 'ca55aaf8bf185b96dfef83636f69d840210906c6619483cac842d89b148cb25b'
AND (
token = '+GTrit8+0ykJih/flC/ySbzq42daOA0djK7ngQJUbb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)