UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PXU+vSnz6lAeNABZ2WLUT84XxRSN65wXhGrSqPCQzls='
WHERE
key_id = '3c31f903b7f2cec135b2837b6c3883182982f18daa9199a4cbc495f6675738f1'
AND (
token = 'PXU+vSnz6lAeNABZ2WLUT84XxRSN65wXhGrSqPCQzls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)