UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8TNCaUAlKWiRnEsyFqyHZmiv2+1U5TvX02t/jMdR2So='
WHERE
key_id = '0a5e1daa8cc09c6d2e55a1ac518fe0b6bcc085fcb069b23633df5f1e557d8944'
AND (
token = '8TNCaUAlKWiRnEsyFqyHZmiv2+1U5TvX02t/jMdR2So='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)