UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXJl/aGNpaR7TcgGQrmkBG571F9f5ymXeQ/kgGkr2aw='
WHERE
key_id = '4899e80ff564b2d370ae28135a31d09e6353b47b46341b5c2b063e0315d304ed'
AND (
token = 'pXJl/aGNpaR7TcgGQrmkBG571F9f5ymXeQ/kgGkr2aw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)