UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlgpgbwRcI+6K90ZPRTCHalOx0+/q7Hh9yDENl4QsJg='
WHERE
key_id = '7038b8d7af7bf013e81b50ddc2d380a4639c1872145db05dbb319c1788be1bee'
AND (
token = 'ZlgpgbwRcI+6K90ZPRTCHalOx0+/q7Hh9yDENl4QsJg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)