UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5K6QmakoW1YJSGW9SBzoRbAu2PhND/rq3+cDLnroKuQ='
WHERE
key_id = '07cabe6c5e4ef119e502baddc3b914c6b4a30eff305e02c3413bda6fe05199a9'
AND (
token = '5K6QmakoW1YJSGW9SBzoRbAu2PhND/rq3+cDLnroKuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)