UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NPHEcKQR85d9ysaj4MjcG+yX80zy1sItLHc40mugurU='
WHERE
key_id = '58f7178d467762877f59553b60877c6b6fae5a905085f16a10b92cee280be3f8'
AND (
token = 'NPHEcKQR85d9ysaj4MjcG+yX80zy1sItLHc40mugurU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)