UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Shzh3/NkAPb23pY0j8g2uqmnSjdvnF9alD0ALsQH4E8='
WHERE
key_id = 'e946e2fc8c1f14aea568ec828c0f44360a3756579cc949fc7bed308c996d649f'
AND (
token = 'Shzh3/NkAPb23pY0j8g2uqmnSjdvnF9alD0ALsQH4E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)