UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1SS6U/QZVT1q2QCUDdVdcqAIelxTmHLqjoASYQvPHc0='
WHERE
key_id = 'c0046870f684aa42037b6040b615e0df00f236d7865757b544029113d3dc19a1'
AND (
token = '1SS6U/QZVT1q2QCUDdVdcqAIelxTmHLqjoASYQvPHc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)