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