UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yVLC7NEbL7lHqAo/W5fAU44DgqH895dbBuDnutlOLWs='
WHERE
key_id = '5e198f114443930d335b29a4d9ec653b2b05715b134f2904d11067410a837bee'
AND (
token = 'yVLC7NEbL7lHqAo/W5fAU44DgqH895dbBuDnutlOLWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)