UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnDwqL0cl2Q0m5ZVM6BPr1OGHGdy50P37r6vj2FFDXI='
WHERE
key_id = 'a9144f7a0bc29b1d6014a6809e4e4f4e8a1bb61f6a550ade89514e6f53463acd'
AND (
token = 'qnDwqL0cl2Q0m5ZVM6BPr1OGHGdy50P37r6vj2FFDXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)