UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K++JZ7cef7myW24roXIo64oA5wMKHmeVV11fEle0ErA='
WHERE
key_id = 'b82fd6a321e2ccfe62437db3f106ce07c8abc650c4d253fa558d17c48a09e73e'
AND (
token = 'K++JZ7cef7myW24roXIo64oA5wMKHmeVV11fEle0ErA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)