UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DYQUJo6/iQ5MS+6c0nlvUThckdVxEURRU3AuHnsSkk='
WHERE
key_id = '28ab9b16c75e1a0656ae2386b78c58dc76681f8c792e86c6ac158d55f7de58a5'
AND (
token = '0DYQUJo6/iQ5MS+6c0nlvUThckdVxEURRU3AuHnsSkk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)