UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3a4oJSOPpU4ktCY4rMcAbe8bj+vBZvOStG2cHPn5MGI='
WHERE
key_id = 'bddca9f4eb340ba415e91b174bb8c834dabcc92734972ea29b4ef6efddb3812a'
AND (
token = '3a4oJSOPpU4ktCY4rMcAbe8bj+vBZvOStG2cHPn5MGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)