UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kHjQ/Lo2e/VVHJJet2i5yttclmS5BptyCIpUzAcBvmc='
WHERE
key_id = 'd47d89f9202ab2a0d72b49deb241009d830f525b192afe5e95c6932c92540873'
AND (
token = 'kHjQ/Lo2e/VVHJJet2i5yttclmS5BptyCIpUzAcBvmc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)