UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D5JDJ2pTK8gsXTGOJBTCxGcqpuapMW0WcbBgsb0Qs0w='
WHERE
key_id = '0c538e89094759e0758142e93b424be9fa2888d9a6196e8d1f4cf0d3ff644019'
AND (
token = 'D5JDJ2pTK8gsXTGOJBTCxGcqpuapMW0WcbBgsb0Qs0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)